/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50533
Source Host           : localhost:59981
Source Database       : jfk_demo

Target Server Type    : MYSQL
Target Server Version : 50599
File Encoding         : 65001

Date: 2017-02-06 16:50:37
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `jfk_dict`
-- ----------------------------
DROP TABLE IF EXISTS `jfk_dict`;
CREATE TABLE `jfk_dict` (
`id`  int(15) NOT NULL AUTO_INCREMENT ,
`dict_type`  int(15) NULL DEFAULT NULL ,
`dict_value`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`showOrder`  int(4) NULL DEFAULT NULL COMMENT '显示顺序' ,
`status`  int(15) NULL DEFAULT 100301 ,
`creator`  int(15) NULL DEFAULT NULL ,
`description`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`createTime`  timestamp NULL DEFAULT CURRENT_TIMESTAMP ,
PRIMARY KEY (`id`),
FOREIGN KEY (`dict_type`) REFERENCES `jfk_dict_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
INDEX `fk_dict_1` (`dict_type`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=300004

;

-- ----------------------------
-- Records of jfk_dict
-- ----------------------------
BEGIN;
INSERT INTO `jfk_dict` VALUES ('100101', '1001', '是', '1', '100301', '1', null, '2015-08-21 18:54:26'), ('100102', '1001', '否', '2', '100301', '1', '不是的', null), ('100300', '1003', '无效', '2', '100300', '1', '失效', null), ('100301', '1003', '有效', '1', '1', '1', '有效', null), ('100303', '1003', '未知', '3', '100301', '2', null, null), ('100800', '1008', '未激活', '4', '100301', '1', '未激活', '2015-09-01 09:49:36'), ('100801', '1008', '激活', '2', '100301', '1', '激活', '2015-09-01 09:50:07'), ('100802', '1008', '业务暂停', '3', '100301', '1', '业务暂停', '2015-09-01 09:50:30'), ('100900', '1009', '点火', null, '100301', null, '车辆点火', '2015-09-01 11:07:49'), ('100901', '1009', '熄火', null, '100301', null, '车辆熄火', '2015-09-01 11:08:33'), ('101000', '1010', '未处理', '1', '100301', null, null, '2015-09-10 09:00:40'), ('101001', '1010', '已处理', '2', '100301', null, null, '2015-09-10 09:01:07'), ('101101', '1011', 'TBOX电量不足', '1', '100301', null, null, '2015-10-12 17:57:57'), ('101102', '1011', '车辆异常情况报警', '2', '100301', null, null, '2015-10-12 18:03:58'), ('101103', '1011', 'TBOX异常情况报警', '3', '100301', null, null, '2015-10-12 18:05:41'), ('101120', '1011', '行车告警', '4', '100301', null, null, '2015-10-12 18:07:03'), ('101130', '1011', 'BCall告警', '5', '100301', null, null, '2015-10-29 11:27:00'), ('300001', '1002', '女', '1', '100301', '1', '女的', null), ('300002', '1002', '男', '2', '100301', '1', '男的', null), ('300003', null, null, null, '100301', '1', null, '2015-10-13 17:42:32');
COMMIT;

-- ----------------------------
-- Table structure for `jfk_dict_type`
-- ----------------------------
DROP TABLE IF EXISTS `jfk_dict_type`;
CREATE TABLE `jfk_dict_type` (
`id`  int(15) NOT NULL AUTO_INCREMENT ,
`enName`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '英文名称' ,
`cnName`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '中文名称' ,
`description`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据字典类型描述' ,
`creator`  int(15) NOT NULL ,
`status`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '100301' ,
`createTime`  timestamp NULL DEFAULT CURRENT_TIMESTAMP ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='数据字典类型'
AUTO_INCREMENT=1012

;

-- ----------------------------
-- Records of jfk_dict_type
-- ----------------------------
BEGIN;
INSERT INTO `jfk_dict_type` VALUES ('1001', 'yesNo', '是否', '标识“是、否”状态', '28', '100301', null), ('1002', 'sex', '性别', '人员性别', '1', '100301', null), ('1003', 'dataStatus', '数据状态', '有效、失效', '1', '100301', null), ('1008', 'TBoxActiveStatus', '激活状态', 'TBOX设备激活状态（0:NoActive;1:Active;2:Stop Business）', '1', '100301', '2015-09-01 09:47:29'), ('1009', 'accStatus', '点火状态', '车辆点火状态 （0 ：点火信息上报； 1：熄火信息上报）', '1', '100301', '2015-09-01 11:07:05'), ('1010', 'TBoxMsgDisposeStatus', 'TBox消息处理状态', null, '1', '100301', '2015-09-10 08:59:44'), ('1011', 'TBoxAlertType', '告警类型', '0601:静态告警;0602:动态告警', '1', '100301', '2015-10-10 17:39:52');
COMMIT;

-- ----------------------------
-- Table structure for `jfk_menu`
-- ----------------------------
DROP TABLE IF EXISTS `jfk_menu`;
CREATE TABLE `jfk_menu` (
`id`  int(15) NOT NULL AUTO_INCREMENT ,
`name`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`url`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`type`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`menu_level`  smallint(6) NULL DEFAULT 0 ,
`icon`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`order_num`  smallint(6) NULL DEFAULT 0 ,
`pid`  int(15) NULL DEFAULT NULL ,
`target`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`rel`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`status`  int(15) NULL DEFAULT 100301 ,
`remark`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`createTime`  timestamp NULL DEFAULT CURRENT_TIMESTAMP ,
`creator`  int(15) NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=21

;

-- ----------------------------
-- Records of jfk_menu
-- ----------------------------
BEGIN;
INSERT INTO `jfk_menu` VALUES ('1', 'root', null, null, '0', null, '0', null, null, null, '1', null, null, null), ('3', '数据字典类型', 'sys/dictionary/dictType/list', null, '0', null, '0', '2', null, null, '1', null, null, null), ('5', '数据字典值', 'sys/dictionary/dict/list', null, '0', null, '0', '2', null, null, '1', null, null, null), ('6', '用户管理', 'sys/user/list', null, '0', null, '0', '2', null, null, '1', null, null, null), ('7', '用户组管理', 'sys/org/list', null, '0', null, '0', '2', null, null, '1', null, null, null), ('8', '其他设置', '/#', null, '0', null, '0', '2', null, null, '0', null, null, null), ('9', '角色管理', 'sys/role/list', null, '0', null, '0', '2', null, null, '1', null, null, null), ('10', '菜单管理', 'sys/menu/list', null, '0', null, '0', '2', null, null, '1', null, null, null), ('11', 'TBOX', '', null, '0', 'fa fa-dashboard', '1000', '1', null, null, '100301', null, '2015-09-01 11:17:26', '1'), ('12', '设备列表', 'tbox/tboxDevice/list', null, '0', null, '0', '11', null, null, '100301', null, '2015-09-01 11:20:42', '1'), ('13', '消息日志', 'tbox/tboxMsgLog/list', null, '0', null, '2', '11', null, null, '100301', null, '2015-09-09 16:08:17', '1'), ('14', '待处理告警列表', 'tbox/tboxMsgLog/list2dispose', null, '0', null, '1', '11', null, null, '100301', null, '2015-10-08 16:22:54', '1'), ('20', '系统管理', '', null, '0', 'fa fa-bar-chart-o', '9900', '1', null, null, '1', null, null, null);
COMMIT;

-- ----------------------------
-- Table structure for `jfk_org`
-- ----------------------------
DROP TABLE IF EXISTS `jfk_org`;
CREATE TABLE `jfk_org` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`groupName`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`pid`  int(11) NULL DEFAULT NULL ,
`description`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`showOrder`  int(11) NULL DEFAULT NULL ,
`status`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '100301' ,
`creator`  int(11) NULL DEFAULT NULL ,
`createTime`  timestamp NULL DEFAULT CURRENT_TIMESTAMP ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='组织机构表'
AUTO_INCREMENT=3

;

-- ----------------------------
-- Records of jfk_org
-- ----------------------------
BEGIN;
INSERT INTO `jfk_org` VALUES ('1', 'root', null, null, null, '0', '1', null), ('2', 'group1', '1', '第一个分组', '2', '100300', '1', '2015-08-21 18:25:56');
COMMIT;

-- ----------------------------
-- Table structure for `jfk_role`
-- ----------------------------
DROP TABLE IF EXISTS `jfk_role`;
CREATE TABLE `jfk_role` (
`id`  int(15) NOT NULL AUTO_INCREMENT ,
`roleName`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`creator`  int(15) NULL DEFAULT NULL ,
`createTime`  timestamp NULL DEFAULT CURRENT_TIMESTAMP ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of jfk_role
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `jfk_role_urls`
-- ----------------------------
DROP TABLE IF EXISTS `jfk_role_urls`;
CREATE TABLE `jfk_role_urls` (
`id`  int(15) NOT NULL DEFAULT 0 ,
`roleId`  int(15) NULL DEFAULT NULL ,
`urlId`  int(15) NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of jfk_role_urls
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `jfk_urls`
-- ----------------------------
DROP TABLE IF EXISTS `jfk_urls`;
CREATE TABLE `jfk_urls` (
`id`  int(15) NOT NULL AUTO_INCREMENT ,
`name`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`url`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`description`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`url_module`  int(15) NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=16

;

-- ----------------------------
-- Records of jfk_urls
-- ----------------------------
BEGIN;
INSERT INTO `jfk_urls` VALUES ('1', '数据字典类型', 'sys/dictionary/dictType/list', '定义数据字典的类型', '1'), ('2', '数据字典值', 'sys/dictionary/dict/list', '设置数据字典的值', '1'), ('3', '用户管理', 'sys/user/list', '对管理员用户进行管理', '1'), ('4', '菜单管理', 'sys/menu/list', '对系统菜单进行管理', '1'), ('5', '个人属性', 'sys/user/profile', '修改自己的密码和基本属性', '1'), ('6', '数据字典类型', 'sys/dictionary/dictType/edit', '编辑数据字典类型', '1'), ('7', '数据字典值', 'sys/dictionary/dict/edit', '编辑数据字典值', '1'), ('8', '用户组列表', 'sys/org/list', '用户组列表', '1'), ('9', '编辑用户组', 'sys/org/edit', '编辑用户组', '1'), ('10', 'TBOX设备列表', 'tbox/tboxDevice/list', 'TBOX设备列表', '2'), ('11', '编辑TBOX设备', 'tbox/tboxDevice/edit', '编辑TBOX设备', '2'), ('12', 'TBOX消息日志列表', 'tbox/tboxMsgLog/list', 'TBOX消息日志列表', '2'), ('13', '编辑TBOX消息日志', 'tbox/tboxMsgLog/edit', '编辑TBOX消息日志', '2'), ('14', '处理TBOX消息', 'tbox/tboxMsgLog/dispose', '处理TBOX消息', '2'), ('15', '待处理告警列表', 'tbox/tboxMsgLog/list2dispose', '待处理告警列表', '1');
COMMIT;

-- ----------------------------
-- Table structure for `jfk_user`
-- ----------------------------
DROP TABLE IF EXISTS `jfk_user`;
CREATE TABLE `jfk_user` (
`id`  int(15) NOT NULL AUTO_INCREMENT ,
`loginName`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '登录名' ,
`password`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码' ,
`realName`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '真实姓名' ,
`email`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电子邮箱' ,
`mobile`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号码' ,
`remark`  longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注' ,
`picture`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像' ,
`createTime`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' ,
`creator`  int(15) NOT NULL COMMENT '创建人' ,
`status`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '100301' COMMENT '状态' ,
`groupId`  int(15) NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='管理员表'
AUTO_INCREMENT=24568

;

-- ----------------------------
-- Records of jfk_user
-- ----------------------------
BEGIN;
INSERT INTO `jfk_user` VALUES ('1', 'admin', '$shiro1$SHA-256$500000$b/VtLJjlYSDhuKQjN8W1Lw==$+eaJIgRj5ALKa5ujIJu+ukXolGWlwFGDjoZzyLAkLzg=', '管理员', 'admin@jfk.com', '13800000000', '1123223', 'upload/image/2015/10/16/JYIR.jpg', '2015-08-20 15:28:26', '1', '100301', null), ('2', '2q', '$shiro1$SHA-256$500000$aJTpfMmTVMypIluU5D6IDA==$JhS/Pnta1zooU63B0nutaZxxe584Rz+BXTcC0scu6fs=', 'de', 'admin@jfk.com', '13300000000', '4456', 'upload/image/2015/08/25/RWFJ.jpg', '2015-04-09 17:21:53', '2', '100301', null), ('3', '3', '$shiro1$SHA-256$500000$lW+JiVoiusz8uvbjRu9hCw==$ySnIbLmCtEJVfMCz9J9afgSnpuEPjK0M90UbY8It3Rk=', null, 'admin@jfk.com', '123', '4456', null, '2015-04-09 15:59:07', '3', '100300', null), ('20', '20', '$shiro1$SHA-256$500000$nvyKu8TGevIahX30ZA3Z6Q==$eZDJdK8lqFUJslOfvXzsrlB3ihd2z5ex0Al3J9K0WRs=', '20', 'admin@jfk.com', '123', '4456', null, '2015-04-14 16:04:35', '20', '100301', null), ('28', '张三', '$shiro1$SHA-256$500000$lbTa43l1VZYiO40fn25Wxg==$msTa+01blRgZJ70VcTdurd3f9SnWdifV+i/ZXL2rlNw=', null, 'admin@jfk.com', '123', '4456', null, '2015-04-09 15:54:05', '77', '100301', null), ('37', '37', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '77', '100301', null), ('60', '60', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '77', '100301', null), ('64', '64', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('65', '65', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('76', '76', 'admin', null, 'admin@jfk.com', '123', '121', null, '2015-03-25 19:20:45', '0', '100301', null), ('77', '77', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('78', '78', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('79', '79', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('80', '80', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('81', '81', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('82', '82', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('84', '84', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('86', '86', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('87', '87', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('90', '90', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('147', '147', 'admin', '管理员147', 'admin@jfk.com', '123', '4456', null, '2015-03-22 22:23:04', '0', '100301', null), ('148', '148', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('149', '149', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('150', '150', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('151', '151', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('152', '152', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('153', '153', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('159', '159', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('160', '160', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('162', '162', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('168', '168', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('169', '169', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('173', '173', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('174', '174', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('175', '175', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('176', '176', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('178', '178', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('180', '180', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('181', '181', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('182', '182', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('183', '183', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('184', '184', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null), ('185', '185', 'admin', null, 'admin@jfk.com', '123', '4456', null, '2014-12-28 21:25:45', '0', '100301', null);
COMMIT;

-- ----------------------------
-- Table structure for `jfk_user_role`
-- ----------------------------
DROP TABLE IF EXISTS `jfk_user_role`;
CREATE TABLE `jfk_user_role` (
`id`  int(15) NOT NULL DEFAULT 0 ,
`userId`  int(15) NULL DEFAULT NULL ,
`roleId`  int(15) NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of jfk_user_role
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `t1`
-- ----------------------------
DROP TABLE IF EXISTS `t1`;
CREATE TABLE `t1` (
`c1`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of t1
-- ----------------------------
BEGIN;
INSERT INTO `t1` VALUES ('$,1'), ('$,1,11,20'), ('$,1,11,20,10,12,13,14'), ('$,3'), ('$,5'), ('$,6'), ('$,7'), ('$,8'), ('$,9'), ('$,10'), ('$,11'), ('$,11,12,13,14'), ('$,12'), ('$,13'), ('$,14'), ('$,20'), ('$,20,10');
COMMIT;

-- ----------------------------
-- Table structure for `tbox_device`
-- ----------------------------
DROP TABLE IF EXISTS `tbox_device`;
CREATE TABLE `tbox_device` (
`id`  int(15) NOT NULL AUTO_INCREMENT ,
`sn`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备唯一标识号' ,
`sim`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`imsi`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`vin`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '车架号' ,
`vPlate`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '车牌号码' ,
`vUser`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '车主姓名' ,
`vEcall`  varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '紧急联系方式' ,
`activeStatus`  int(1) NOT NULL DEFAULT 100801 ,
`creator`  int(15) NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=3

;

-- ----------------------------
-- Records of tbox_device
-- ----------------------------
BEGIN;
INSERT INTO `tbox_device` VALUES ('1', '15415025L990997913600U0010', '18900000000', '460036641469974', '1111111111111111111111', '沪A*12345', '测试车辆', '18912345678', '100801', '1'), ('2', '15415026L990997913600U0010', '18999009900', '460036641469975', '460036641469975', '沪A.98765', '王老五', '18999009900', '100801', '1');
COMMIT;

-- ----------------------------
-- Table structure for `tbox_msglog`
-- ----------------------------
DROP TABLE IF EXISTS `tbox_msglog`;
CREATE TABLE `tbox_msglog` (
`id`  int(15) NOT NULL AUTO_INCREMENT ,
`aid`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`mid`  varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`eventId`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`sn`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`imsi`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`vin`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`appData`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`eventTime`  datetime NULL DEFAULT NULL ,
`createTime`  timestamp NULL DEFAULT CURRENT_TIMESTAMP ,
`creator`  int(15) NULL DEFAULT NULL ,
`disposeStatus`  int(15) NULL DEFAULT 101000 COMMENT '处理状态' ,
`disposeContent`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '处理结果' ,
`disposeUser`  int(15) NULL DEFAULT NULL COMMENT '处理人' ,
`disposeTime`  datetime NULL DEFAULT NULL COMMENT '处理时间' ,
`isCallUser`  int(15) NULL DEFAULT NULL ,
`isECall`  int(15) NULL DEFAULT NULL ,
`isRescue`  int(15) NULL DEFAULT NULL ,
`data`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`desc`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`alertType`  int(15) NULL DEFAULT NULL ,
`ip`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=394

;

-- ----------------------------
-- Records of tbox_msglog
-- ----------------------------
BEGIN;
INSERT INTO `tbox_msglog` VALUES ('393', '0901', '1', '000000000000', '15415026L990997913600U0010', '460036641469975', '11111111111111111', '00000000000000000000000000B24112A4060000000000001D0000000000000000000000000000000000000000000000000000000000', '2064-10-07 12:44:20', '2015-11-13 14:04:55', null, '101000', null, null, null, null, null, null, '464C432E00008D005700B24112A40000000000000901000101000036000000000000313131313131313131313131313131313131353431353032364C3939303939373931333630305530303130343630303336363431343639393735010203040000000000000000000000000000B24112A4060000000000001D00000000000000000000000000000000000000000000000000000000008B', null, '101130', '/127.0.0.1:14249');
COMMIT;

-- ----------------------------
-- Table structure for `tbox_msglog_copy`
-- ----------------------------
DROP TABLE IF EXISTS `tbox_msglog_copy`;
CREATE TABLE `tbox_msglog_copy` (
`id`  int(15) NOT NULL AUTO_INCREMENT ,
`aid`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`mid`  varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`eventId`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`sn`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`imsi`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`vin`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`appData`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`eventTime`  datetime NULL DEFAULT NULL ,
`createTime`  timestamp NULL DEFAULT CURRENT_TIMESTAMP ,
`creator`  int(15) NULL DEFAULT NULL ,
`disposeStatus`  int(15) NULL DEFAULT 101000 COMMENT '处理状态' ,
`disposeContent`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '处理结果' ,
`disposeUser`  int(15) NULL DEFAULT NULL COMMENT '处理人' ,
`disposeTime`  datetime NULL DEFAULT NULL COMMENT '处理时间' ,
`isCallUser`  int(15) NULL DEFAULT NULL ,
`isECall`  int(15) NULL DEFAULT NULL ,
`isRescue`  int(15) NULL DEFAULT NULL ,
`data`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`desc`  varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`alertType`  int(15) NULL DEFAULT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=202

;

-- ----------------------------
-- Records of tbox_msglog_copy
-- ----------------------------
BEGIN;
INSERT INTO `tbox_msglog_copy` VALUES ('68', '0602', '1', '000000000000', '15415025L990997913600U0010', '460036641469974', '11111111111111111aaaaaaaaaaaaaaaaaa', '010000000100000001000000010000400000004000404000BBD04F3A100001000008000E0000', '2001-01-01 00:35:07', '2015-09-29 10:15:12', null, '101001', null, null, null, null, null, null, '464C432E00007D00570085F549910000000000000602000107000026000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400010000000100000001000000010000400000004000404000BBD04F3A100001000008000E0000D9', null, '101120'), ('69', '0602', '1', '000000000000', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '010000000100000001000000010000400000004000404000BBD04F3A100001000008000E0000', '2001-01-01 00:35:07', '2015-09-29 10:20:23', null, '101000', null, null, null, null, null, null, '464C432E00007D00570085F549910000000000000602000107000026000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400010000000100000001000000010000400000004000404000BBD04F3A100001000008000E0000D9', null, '101120'), ('70', '0602', '1', '000000000000', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '010000000100000001000000010000400000004000404000BBD04F3A100001000008000E0000', '2001-01-01 00:35:07', '2015-09-29 11:17:49', null, '101000', null, null, null, null, null, null, '464C432E00007D00570085F549910000000000000602000107000026000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400010000000100000001000000010000400000004000404000BBD04F3A100001000008000E0000D9', null, '101120'), ('71', '0602', '1', '000000000000', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '010000000100000001000000010000400000004000404000BBD04F3A100001000008000E0000', '2001-01-01 00:35:07', '2015-09-29 11:47:36', null, '101000', null, null, null, null, null, null, '464C432E00007D00570085F549910000000000000602000107000026000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400010000000100000001000000010000400000004000404000BBD04F3A100001000008000E0000D9', null, '101120'), ('72', '0602', '1', '000000000000', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '7D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A4400', '2001-01-01 00:26:43', '2015-09-29 12:44:35', null, '101000', null, null, null, null, null, null, '464C432E0000750057008C621742000000000000060200010100001E000000000000313131313131313131313131313131313131353431353032354C393930393937393133363030553030313034363030333636343134363939373401020304007D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A44009B', null, '101120'), ('73', '0602', '1', '000000000000', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '7D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A4400', '2001-01-01 00:26:43', '2015-09-29 12:44:42', null, '101000', null, null, null, null, null, null, '464C432E0000750057008C621748000000000000060200010200001E000000000000313131313131313131313131313131313131353431353032354C393930393937393133363030553030313034363030333636343134363939373401020304007D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A440092', null, '101120'), ('74', '0602', '1', '000000000000', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '7D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A4400', '2001-01-01 00:26:43', '2015-09-29 12:44:48', null, '101000', null, null, null, null, null, null, '464C432E0000750057008C62174E000000000000060200010300001E000000000000313131313131313131313131313131313131353431353032354C393930393937393133363030553030313034363030333636343134363939373401020304007D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A440095', null, '101120'), ('75', '0602', '1', '000000000000', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '7D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A4400', '2001-01-01 00:26:43', '2015-09-29 12:44:54', null, '101000', null, null, null, null, null, null, '464C432E0000750057008C621754000000000000060200010400001E000000000000313131313131313131313131313131313131353431353032354C393930393937393133363030553030313034363030333636343134363939373401020304007D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A440088', null, '101120'), ('76', '0602', '1', '000000000000', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '7D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A4400', '2001-01-01 00:26:43', '2015-09-29 12:45:00', null, '101000', null, null, null, null, null, null, '464C432E0000750057008C62175A000000000000060200010500001E000000000000313131313131313131313131313131313131353431353032354C393930393937393133363030553030313034363030333636343134363939373401020304007D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A440087', null, '101120'), ('77', '0602', '1', '000000000000', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '7D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A4400', '2001-01-01 00:26:43', '2015-09-29 12:45:06', null, '101000', null, null, null, null, null, null, '464C432E0000750057008C621761000000000000060200010600001E000000000000313131313131313131313131313131313131353431353032354C393930393937393133363030553030313034363030333636343134363939373401020304007D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A4400BF', null, '101120'), ('78', '0602', '1', '000000000000', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '7D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A4400', '2001-01-01 00:26:43', '2015-09-29 12:45:44', null, '101000', null, null, null, null, null, null, '464C432E0000750057008C621787000000000000060200010700001E000000000000313131313131313131313131313131313131353431353032354C393930393937393133363030553030313034363030333636343134363939373401020304007D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A440058', null, '101120'), ('79', '0602', '1', '000000000000', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '7D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A4400', '2001-01-01 00:26:43', '2015-09-29 12:45:50', null, '101001', '的', null, null, '100101', null, null, '464C432E0000750057008C62178D000000000000060200010800001E000000000000313131313131313131313131313131313131353431353032354C393930393937393133363030553030313034363030333636343134363939373401020304007D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A44005D', null, '101120'), ('80', '0602', '1', '000000000000', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '7D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A4400', '2001-01-01 00:26:43', '2015-09-29 12:45:56', null, '101000', null, null, null, null, null, null, '464C432E0000750057008C621793000000000000060200010900001E000000000000313131313131313131313131313131313131353431353032354C393930393937393133363030553030313034363030333636343134363939373401020304007D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A440042', null, '101120'), ('81', '0602', '1', '000000000000', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '7D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A4400', '2001-01-01 00:26:43', '2015-09-29 12:46:02', null, '101000', null, null, null, null, null, null, '464C432E0000750057008C621799000000000000060200010A00001E000000000000313131313131313131313131313131313131353431353032354C393930393937393133363030553030313034363030333636343134363939373401020304007D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A44004B', null, '101120'), ('82', '0602', '1', '000000000000', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '7D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A4400', '2001-01-01 00:26:43', '2015-09-29 12:46:08', null, '101000', null, null, null, null, null, null, '464C432E0000750057008C62179F000000000000060200010B00001E000000000000313131313131313131313131313131313131353431353032354C393930393937393133363030553030313034363030333636343134363939373401020304007D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A44004C', null, '101120'), ('83', '0602', '1', '000000000000', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '7D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A4400', '2001-01-01 00:26:43', '2015-09-29 12:46:14', null, '101000', null, null, null, null, null, null, '464C432E0000750057008C6217A5000000000000060200010C00001E000000000000313131313131313131313131313131313131353431353032354C393930393937393133363030553030313034363030333636343134363939373401020304007D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A440071', null, '101120'), ('84', '0602', '1', '000000000000', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '7D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A0300', '2001-01-01 00:26:43', '2015-09-29 13:05:37', null, '101001', '的', null, null, '100101', '100101', '100101', '464C432E0000750057008C621C2F000000000000060200010D00001E000000000000313131313131313131313131313131313131353431353032354C393930393937393133363030553030313034363030333636343134363939373401020304007D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A0300B6', null, '101120'), ('85', '0602', '1', '000000000000', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '7D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A0300', '2001-01-01 00:26:43', '2015-09-29 13:05:43', null, '101000', null, null, null, null, null, null, '464C432E0000750057008C621C35000000000000060200010E00001E000000000000313131313131313131313131313131313131353431353032354C393930393937393133363030553030313034363030333636343134363939373401020304007D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A0300AF', null, '101120'), ('86', '0602', '1', '000000000000', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '7D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A0300', '2001-01-01 00:26:43', '2015-09-29 13:05:49', null, '101000', null, null, null, null, null, null, '464C432E0000750057008C621C3B000000000000060200010F00001E000000000000313131313131313131313131313131313131353431353032354C393930393937393133363030553030313034363030333636343134363939373401020304007D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A0300A0', null, '101120'), ('87', '0602', '1', '000000000000', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '7D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A0300', '2001-01-01 00:26:43', '2015-09-29 13:05:55', null, '101000', null, null, null, null, null, null, '464C432E0000750057008C621C41000000000000060200011000001E000000000000313131313131313131313131313131313131353431353032354C393930393937393133363030553030313034363030333636343134363939373401020304007D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A0300C5', null, '101120'), ('88', '0602', '1', '000000000000', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '7D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A0300', '2001-01-01 00:26:43', '2015-09-29 13:06:01', null, '101000', null, null, null, null, null, null, '464C432E0000750057008C621C48000000000000060200011100001E000000000000313131313131313131313131313131313131353431353032354C393930393937393133363030553030313034363030333636343134363939373401020304007D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A0300CD', null, '101120'), ('89', '0602', '1', '000000000000', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '7D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A0300', '2001-01-01 00:26:43', '2015-09-29 13:06:07', null, '101000', null, null, null, null, null, null, '464C432E0000750057008C621C4E000000000000060200011200001E000000000000313131313131313131313131313131313131353431353032354C393930393937393133363030553030313034363030333636343134363939373401020304007D6CCBEB4D7C1E5A00F0580BE6ADCBEBA5C81E5A00F0484FC3CE4F3A0300C8', null, '101120'), ('90', '0401', '1', '000000000001', '15415025L990997913600U0010', '460036641469974', '11111111111111111', 'FF3131313131313131313131313131313131', '2042-04-17 14:03:02', '2015-10-10 09:38:20', null, '101000', null, null, null, null, null, null, '464C432E00006900570087FABB960000000000010401000101000012000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400FF3131313131313131313131313131313131C0', null, null), ('91', '0601', '1', '000000000002', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '000000000000000000000000000087FABBD9060000000000001D0000000000000000000000000000000000000000000000000000000000', '2042-04-17 14:04:09', '2015-10-10 09:39:27', null, '101000', null, null, null, null, null, null, '464C432E00008E00570087FABBD90000000000020601000102000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400000000000000000000000000000087FABBD9060000000000001D000000000000000000000000000000000000000000000000000000000085', null, '101101'), ('92', '0601', '1', '000000000002', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '000000000000000000000000000087FABBD9060000000000001D0000000000000000000000000000000000000000000000000000000000', '2042-04-17 14:04:09', '2015-10-10 09:39:33', null, '101000', null, null, null, null, null, null, '464C432E00008E00570087FABBD90000000000020601000102000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400000000000000000000000000000087FABBD9060000000000001D000000000000000000000000000000000000000000000000000000000085', null, '101101'), ('93', '0601', '1', '000000000002', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '000000000000000000000000000087FABBD9060000000000001D0000000000000000000000000000000000000000000000000000000000', '2042-04-17 14:04:09', '2015-10-10 09:39:39', null, '101000', null, null, null, null, null, null, '464C432E00008E00570087FABBD90000000000020601000102000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400000000000000000000000000000087FABBD9060000000000001D000000000000000000000000000000000000000000000000000000000085', null, '101101'), ('94', '0601', '1', '000000000002', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '000000000000000000000000000087FABBD9060000000000001D0000000000000000000000000000000000000000000000000000000000', '2042-04-17 14:04:09', '2015-10-10 09:39:45', null, '101000', null, null, null, null, null, null, '464C432E00008E00570087FABBD90000000000020601000102000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400000000000000000000000000000087FABBD9060000000000001D000000000000000000000000000000000000000000000000000000000085', null, '101101'), ('95', '0601', '1', '000000000002', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '000000000000000000000000000087FABBD9060000000000001D0000000000000000000000000000000000000000000000000000000000', '2042-04-17 14:04:09', '2015-10-10 09:39:51', null, '101000', null, null, null, null, null, null, '464C432E00008E00570087FABBD90000000000020601000102000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400000000000000000000000000000087FABBD9060000000000001D000000000000000000000000000000000000000000000000000000000085', null, '101101'), ('96', '0601', '1', '000000000002', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '000000000000000000000000000087FABBD9060000000000001D0000000000000000000000000000000000000000000000000000000000', '2042-04-17 14:04:09', '2015-10-10 09:39:57', null, '101000', null, null, null, null, null, null, '464C432E00008E00570087FABBD90000000000020601000102000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400000000000000000000000000000087FABBD9060000000000001D000000000000000000000000000000000000000000000000000000000085', null, '101101'), ('97', '0601', '1', '000000000003', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '000000000000000000000000000087FABC3F060000000000001D0000000000000000000000000000000000000000000000000000000000', '2042-04-17 14:05:51', '2015-10-10 09:41:09', null, '101000', null, null, null, null, null, null, '464C432E00008E00570087FABC3F0000000000030601000103000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400000000000000000000000000000087FABC3F060000000000001D000000000000000000000000000000000000000000000000000000000085', null, '101101'), ('98', '0401', '1', '000000000001', '15415025L990997913600U0010', '460036641469974', '11111111111111111', 'FF3131313131313131313131313131313131', '2044-06-02 06:15:16', '2015-10-10 10:03:38', null, '101000', null, null, null, null, null, null, '464C432E0000690057008BFAAB740000000000010401000101000012000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400FF31313131313131313131313131313131313E', null, null), ('99', '0601', '1', '000000000002', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '00000000000000000000000000008BFAABB8060000000000001D0000000000000000000000000000000000000000000000000000000000', '2044-06-02 06:16:24', '2015-10-10 10:04:47', null, '101000', null, null, null, null, null, null, '464C432E00008E0057008BFAABB80000000000020601000102000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040000000000000000000000000000008BFAABB8060000000000001D000000000000000000000000000000000000000000000000000000000085', null, '101101'), ('100', '0601', '1', '000000000003', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '00000000000000000000000000008BFAAC1F060000000000001D0000000000000000000000000000000000000000000000000000000000', '2044-06-02 06:18:07', '2015-10-10 10:06:29', null, '101000', null, null, null, null, null, null, '464C432E00008E0057008BFAAC1F0000000000030601000103000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040000000000000000000000000000008BFAAC1F060000000000001D000000000000000000000000000000000000000000000000000000000085', null, '101101'), ('101', '0601', '1', '000000000004', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '00000000000000000000000000008BFAAC84060000000000001D0000000000000000000000000000000000000000000000000000000000', '2044-06-02 06:19:48', '2015-10-10 10:08:10', null, '101000', null, null, null, null, null, null, '464C432E00008E0057008BFAAC840000000000040601000104000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040000000000000000000000000000008BFAAC84060000000000001D000000000000000000000000000000000000000000000000000000000085', null, '101101'), ('102', '0601', '1', '000000000005', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '00000000000000000000000000008BFAACE9060000000000001D0000000000000000000000000000000000000000000000000000000000', '2044-06-02 06:21:29', '2015-10-10 10:09:51', null, '101000', null, null, null, null, null, null, '464C432E00008E0057008BFAACE90000000000050601000105000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040000000000000000000000000000008BFAACE9060000000000001D000000000000000000000000000000000000000000000000000000000085', null, '101101'), ('103', '0601', '1', '000000000006', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '00000000000000000000000000008BFAAD4F060000000000001D0000000000000000000000000000000000000000000000000000000000', '2044-06-02 06:23:11', '2015-10-10 10:11:33', null, '101000', null, null, null, null, null, null, '464C432E00008E0057008BFAAD4F0000000000060601000106000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040000000000000000000000000000008BFAAD4F060000000000001D000000000000000000000000000000000000000000000000000000000085', null, '101101'), ('104', '0601', '1', '000000000007', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '000101DC202F073CDFE10000000056187557060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 02:17:59', '2015-10-10 10:18:21', null, '101000', null, null, null, null, null, null, '464C432E00008E005700561875570000000000070601000107000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400000101DC202F073CDFE10000000056187557060000000000001D000000000000000000000000000000000000000000000000000000000053', null, '101101'), ('105', '0401', '1', '000000000001', '15415025L990997913600U0010', '460036641469974', '11111111111111111', 'FF3131313131313131313131313131313131', '2015-10-10 02:34:49', '2015-10-10 10:36:11', null, '101000', null, null, null, null, null, null, '464C432E000069005700561879490000000000010401000101000012000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400FF3131313131313131313131313131313131EE', null, null), ('106', '0401', '1', '000000000001', '15415025L990997913600U0010', '460036641469974', '11111111111111111', 'FF3131313131313131313131313131313131', '2015-10-10 02:34:49', '2015-10-10 10:36:17', null, '101000', null, null, null, null, null, null, '464C432E000069005700561879490000000000010401000101000012000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400FF3131313131313131313131313131313131EE', null, null), ('107', '0401', '1', '000000000001', '15415025L990997913600U0010', '460036641469974', '11111111111111111', 'FF3131313131313131313131313131313131', '2015-10-10 02:34:49', '2015-10-10 10:36:23', null, '101000', null, null, null, null, null, null, '464C432E000069005700561879490000000000010401000101000012000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400FF3131313131313131313131313131313131EE', null, null), ('108', '0401', '1', '000000000001', '15415025L990997913600U0010', '460036641469974', '11111111111111111', 'FF3131313131313131313131313131313131', '2015-10-10 02:34:49', '2015-10-10 10:36:29', null, '101000', null, null, null, null, null, null, '464C432E000069005700561879490000000000010401000101000012000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400FF3131313131313131313131313131313131EE', null, null), ('109', '0401', '1', '000000000001', '15415025L990997913600U0010', '460036641469974', '11111111111111111', 'FF3131313131313131313131313131313131', '2015-10-10 02:34:49', '2015-10-10 10:36:35', null, '101000', null, null, null, null, null, null, '464C432E000069005700561879490000000000010401000101000012000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400FF3131313131313131313131313131313131EE', null, null), ('110', '0401', '1', '000000000001', '15415025L990997913600U0010', '460036641469974', '11111111111111111', 'FF3131313131313131313131313131313131', '2015-10-10 02:34:49', '2015-10-10 10:36:41', null, '101000', null, null, null, null, null, null, '464C432E000069005700561879490000000000010401000101000012000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400FF3131313131313131313131313131313131EE', null, null), ('111', '0401', '1', '000000000001', '15415025L990997913600U0010', '460036641469974', '11111111111111111', 'FF3131313131313131313131313131313131', '2015-10-10 02:39:28', '2015-10-10 10:40:53', null, '101000', null, null, null, null, null, null, '464C432E00006900570056187A600000000000010401000101000012000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400FF3131313131313131313131313131313131C4', null, null), ('112', '0601', '1', '000000000002', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '010000000000000000000000000056187AA3060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 02:40:35', '2015-10-10 10:42:01', null, '101000', null, null, null, null, null, null, '464C432E00008E00570056187AA30000000000020601000102000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400010000000000000000000000000056187AA3060000000000001D000000000000000000000000000000000000000000000000000000000084', null, '101101'), ('113', '0601', '1', '000000000003', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '010000000000000000000000000056187B09060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 02:42:17', '2015-10-10 10:43:42', null, '101000', null, null, null, null, null, null, '464C432E00008E00570056187B090000000000030601000103000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400010000000000000000000000000056187B09060000000000001D000000000000000000000000000000000000000000000000000000000084', null, '101101'), ('114', '0601', '1', '000000000004', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '010000000000000000000000000056187B6F060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 02:43:59', '2015-10-10 10:45:24', null, '101000', null, null, null, null, null, null, '464C432E00008E00570056187B6F0000000000040601000104000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400010000000000000000000000000056187B6F060000000000001D000000000000000000000000000000000000000000000000000000000084', null, '101101'), ('115', '0601', '1', '000000000005', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '010000000000000000000000000056187BD4060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 02:45:40', '2015-10-10 10:47:06', null, '101000', null, null, null, null, null, null, '464C432E00008E00570056187BD40000000000050601000105000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400010000000000000000000000000056187BD4060000000000001D000000000000000000000000000000000000000000000000000000000084', null, '101101'), ('116', '0601', '1', '000000000006', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '010000000000000000000000000056187C3A060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 02:47:22', '2015-10-10 10:48:47', null, '101000', null, null, null, null, null, null, '464C432E00008E00570056187C3A0000000000060601000106000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400010000000000000000000000000056187C3A060000000000001D000000000000000000000000000000000000000000000000000000000084', null, '101101'), ('117', '0601', '1', '000000000007', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '010000000000000000000000000056187CA0060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 02:49:04', '2015-10-10 10:50:29', null, '101000', null, null, null, null, null, null, '464C432E00008E00570056187CA00000000000070601000107000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400010000000000000000000000000056187CA0060000000000001D000000000000000000000000000000000000000000000000000000000084', null, '101101'), ('118', '0601', '1', '000000000008', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '010000000000000000000000000056187D05060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 02:50:45', '2015-10-10 10:52:11', null, '101000', null, null, null, null, null, null, '464C432E00008E00570056187D050000000000080601000108000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400010000000000000000000000000056187D05060000000000001D000000000000000000000000000000000000000000000000000000000084', null, '101101'), ('119', '0601', '1', '000000000009', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '010000000000000000000000000056187D6B060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 02:52:27', '2015-10-10 10:53:52', null, '101000', null, null, null, null, null, null, '464C432E00008E00570056187D6B0000000000090601000109000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400010000000000000000000000000056187D6B060000000000001D000000000000000000000000000000000000000000000000000000000084', null, '101101'), ('120', '0601', '1', '00000000000A', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '010000000000000000000000000056187DD1060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 02:54:09', '2015-10-10 10:55:34', null, '101000', null, null, null, null, null, null, '464C432E00008E00570056187DD100000000000A060100010A000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400010000000000000000000000000056187DD1060000000000001D000000000000000000000000000000000000000000000000000000000084', null, '101101'), ('121', '0601', '1', '00000000000B', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '010000000000000000000000000056187E36060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 02:55:50', '2015-10-10 10:57:16', null, '101000', null, null, null, null, null, null, '464C432E00008E00570056187E3600000000000B060100010B000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400010000000000000000000000000056187E36060000000000001D000000000000000000000000000000000000000000000000000000000084', null, '101101'), ('122', '0601', '1', '00000000000C', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '010000000000000000000000000056187E9C060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 02:57:32', '2015-10-10 10:58:58', null, '101000', null, null, null, null, null, null, '464C432E00008E00570056187E9C00000000000C060100010C000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400010000000000000000000000000056187E9C060000000000001D000000000000000000000000000000000000000000000000000000000084', null, '101101'), ('123', '0601', '1', '00000000000D', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '010000000000000000000000000056187F02060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 02:59:14', '2015-10-10 11:00:40', null, '101000', null, null, null, null, null, null, '464C432E00008E00570056187F0200000000000D060100010D000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400010000000000000000000000000056187F02060000000000001D000000000000000000000000000000000000000000000000000000000084', null, '101101'), ('124', '0601', '1', '00000000000E', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '010000000000000000000000000056187F67060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 03:00:55', '2015-10-10 11:02:21', null, '101000', null, null, null, null, null, null, '464C432E00008E00570056187F6700000000000E060100010E000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400010000000000000000000000000056187F67060000000000001D000000000000000000000000000000000000000000000000000000000084', null, '101101'), ('125', '0601', '1', '00000000000F', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '010000000000000000000000000056187FCD060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 03:02:37', '2015-10-10 11:04:03', null, '101000', null, null, null, null, null, null, '464C432E00008E00570056187FCD00000000000F060100010F000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400010000000000000000000000000056187FCD060000000000001D000000000000000000000000000000000000000000000000000000000084', null, '101101'), ('126', '0601', '1', '000000000010', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '010000000000000000000000000056188033060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 03:04:19', '2015-10-10 11:05:44', null, '101000', null, null, null, null, null, null, '464C432E00008E005700561880330000000000100601000110000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400010000000000000000000000000056188033060000000000001D000000000000000000000000000000000000000000000000000000000084', null, '101101'), ('127', '0601', '1', '000000000011', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '010000000000000000000000000056188098060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 03:06:00', '2015-10-10 11:07:26', null, '101000', null, null, null, null, null, null, '464C432E00008E005700561880980000000000110601000111000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400010000000000000000000000000056188098060000000000001D000000000000000000000000000000000000000000000000000000000084', null, '101101'), ('128', '0601', '1', '000000000012', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '0100000000000000000000000000561880FF060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 03:07:43', '2015-10-10 11:09:09', null, '101000', null, null, null, null, null, null, '464C432E00008E005700561880FF0000000000120601000112000037000000000000313131313131313131313131313131313131353431353032354C393930393937393133363030553030313034363030333636343134363939373401020304000100000000000000000000000000561880FF060000000000001D000000000000000000000000000000000000000000000000000000000084', null, '101101'), ('129', '0601', '1', '000000000013', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '010000000000000000000000000056188166060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 03:09:26', '2015-10-10 11:10:49', null, '101000', null, null, null, null, null, null, '464C432E00008E005700561881660000000000130601000113000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400010000000000000000000000000056188166060000000000001D000000000000000000000000000000000000000000000000000000000084', null, '101101'), ('130', '0601', '1', '000000000014', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '0100000000000000000000000000561881CC060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 03:11:08', '2015-10-10 11:12:32', null, '101000', null, null, null, null, null, null, '464C432E00008E005700561881CC0000000000140601000114000037000000000000313131313131313131313131313131313131353431353032354C393930393937393133363030553030313034363030333636343134363939373401020304000100000000000000000000000000561881CC060000000000001D000000000000000000000000000000000000000000000000000000000084', null, '101101'), ('131', '0601', '1', '000000000016', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '010000000000000000000000000056188297060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 03:14:31', '2015-10-10 11:15:55', null, '101000', null, null, null, null, null, null, '464C432E00008E005700561882970000000000160601000116000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400010000000000000000000000000056188297060000000000001D000000000000000000000000000000000000000000000000000000000084', null, '101101'), ('132', '0601', '1', '000000000017', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '0100000000000000000000000000561882FC060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 03:16:12', '2015-10-10 11:17:36', null, '101000', null, null, null, null, null, null, '464C432E00008E005700561882FC0000000000170601000117000037000000000000313131313131313131313131313131313131353431353032354C393930393937393133363030553030313034363030333636343134363939373401020304000100000000000000000000000000561882FC060000000000001D000000000000000000000000000000000000000000000000000000000084', null, '101101'), ('133', '0401', '1', '000000000001', '15415025L990997913600U0010', '460036641469974', '11111111111111111', 'FF3131313131313131313131313131313131', '2015-10-10 03:18:16', '2015-10-10 11:19:41', null, '101000', null, null, null, null, null, null, '464C432E000069005700561883780000000000010401000101000012000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400FF313131313131313131313131313131313125', null, null), ('134', '0601', '1', '000000000002', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '0100000000000000000000000000561883BB060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 03:19:23', '2015-10-10 11:20:48', null, '101000', null, null, null, null, null, null, '464C432E00008E005700561883BB0000000000020601000102000037000000000000313131313131313131313131313131313131353431353032354C393930393937393133363030553030313034363030333636343134363939373401020304000100000000000000000000000000561883BB060000000000001D000000000000000000000000000000000000000000000000000000000084', null, '101101'), ('135', '0601', '1', '000000000003', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '0100000000000000000000000000561884EC060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 03:24:28', '2015-10-10 11:25:53', null, '101000', null, null, null, null, null, null, '464C432E00008E005700561884EC0000000000030601000103000037000000000000313131313131313131313131313131313131353431353032354C393930393937393133363030553030313034363030333636343134363939373401020304000100000000000000000000000000561884EC060000000000001D000000000000000000000000000000000000000000000000000000000084', null, '101101'), ('136', '0601', '1', '000000000004', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '010000000000000000000000000056188552060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 03:26:10', '2015-10-10 11:27:37', null, '101000', null, null, null, null, null, null, '464C432E00008E005700561885520000000000040601000104000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400010000000000000000000000000056188552060000000000001D000000000000000000000000000000000000000000000000000000000084', null, '101101'), ('137', '0601', '1', '000000000005', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '010101DC2083073CE0EF00000000561885F8060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 03:28:56', '2015-10-10 11:29:17', null, '101000', null, null, null, null, null, null, '464C432E00008E005700561885F80000000000050601000105000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400010101DC2083073CE0EF00000000561885F8060000000000001D0000000000000000000000000000000000000000000000000000000000CF', null, '101101'), ('138', '0601', '1', '000000000006', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '010101DC2228073CDFFA000000005618865D060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 03:30:37', '2015-10-10 11:30:58', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618865D0000000000060601000106000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400010101DC2228073CDFFA000000005618865D060000000000001D00000000000000000000000000000000000000000000000000000000004C', null, '101101'), ('139', '0601', '1', '000000000007', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '010101DC2018073CE0FA00000000561886C3060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 03:32:19', '2015-10-10 11:32:40', null, '101000', null, null, null, null, null, null, '464C432E00008E005700561886C30000000000070601000107000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400010101DC2018073CE0FA00000000561886C3060000000000001D000000000000000000000000000000000000000000000000000000000041', null, '101101'), ('140', '0401', '1', '000000000001', '15415025L990997913600U0010', '460036641469974', '11111111111111111', 'FF3131313131313131313131313131313131', '2015-10-10 03:35:11', '2015-10-10 11:35:33', null, '101000', null, null, null, null, null, null, '464C432E0000690057005618876F0000000000010401000101000012000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400FF313131313131313131313131313131313136', null, null), ('141', '0601', '1', '000000000002', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '0200000000000000000000000000561887B3060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 03:36:19', '2015-10-10 11:36:41', null, '101000', null, null, null, null, null, null, '464C432E00008E005700561887B30000000000020601000102000037000000000000313131313131313131313131313131313131353431353032354C393930393937393133363030553030313034363030333636343134363939373401020304000200000000000000000000000000561887B3060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('142', '0601', '1', '000000000003', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618881C060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 03:38:04', '2015-10-10 11:38:26', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618881C0000000000030601000103000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618881C060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('143', '0601', '1', '000000000004', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618887E060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 03:39:42', '2015-10-10 11:40:04', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618887E0000000000040601000104000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618887E060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('144', '0601', '1', '000000000005', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '0200000000000000000000000000561888E4060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 03:41:24', '2015-10-10 11:41:46', null, '101000', null, null, null, null, null, null, '464C432E00008E005700561888E40000000000050601000105000037000000000000313131313131313131313131313131313131353431353032354C393930393937393133363030553030313034363030333636343134363939373401020304000200000000000000000000000000561888E4060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('145', '0601', '1', '000000000006', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618894A060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 03:43:06', '2015-10-10 11:43:28', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618894A0000000000060601000106000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618894A060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('146', '0601', '1', '000000000007', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '0200000000000000000000000000561889AF060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 03:44:47', '2015-10-10 11:45:09', null, '101000', null, null, null, null, null, null, '464C432E00008E005700561889AF0000000000070601000107000037000000000000313131313131313131313131313131313131353431353032354C393930393937393133363030553030313034363030333636343134363939373401020304000200000000000000000000000000561889AF060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('147', '0601', '1', '000000000008', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '020000000000000000000000000056188A15060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 03:46:29', '2015-10-10 11:46:51', null, '101000', null, null, null, null, null, null, '464C432E00008E00570056188A150000000000080601000108000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400020000000000000000000000000056188A15060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('148', '0601', '1', '000000000009', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '020000000000000000000000000056188A7B060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 03:48:11', '2015-10-10 11:48:33', null, '101000', null, null, null, null, null, null, '464C432E00008E00570056188A7B0000000000090601000109000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400020000000000000000000000000056188A7B060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('149', '0601', '1', '00000000000A', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '020000000000000000000000000056188AE0060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 03:49:52', '2015-10-10 11:50:15', null, '101000', null, null, null, null, null, null, '464C432E00008E00570056188AE000000000000A060100010A000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400020000000000000000000000000056188AE0060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('150', '0601', '1', '00000000000B', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '020000000000000000000000000056188B47060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 03:51:35', '2015-10-10 11:51:57', null, '101000', null, null, null, null, null, null, '464C432E00008E00570056188B4700000000000B060100010B000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400020000000000000000000000000056188B47060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('151', '0601', '1', '00000000000C', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '020000000000000000000000000056188BAC060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 03:53:16', '2015-10-10 11:53:38', null, '101000', null, null, null, null, null, null, '464C432E00008E00570056188BAC00000000000C060100010C000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400020000000000000000000000000056188BAC060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('152', '0601', '1', '00000000000D', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '020101DC226B073CE0800000000056189F88060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 05:18:00', '2015-10-10 13:18:23', null, '101000', null, null, null, null, null, null, '464C432E00008E00570056189F8800000000000D060100010D000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400020101DC226B073CE0800000000056189F88060000000000001D000000000000000000000000000000000000000000000000000000000049', null, '101102'), ('153', '0601', '1', '00000000000E', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '020101DC2069073CE1790000000056189FED060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 05:19:41', '2015-10-10 13:20:05', null, '101000', null, null, null, null, null, null, '464C432E00008E00570056189FED00000000000E060100010E000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400020101DC2069073CE1790000000056189FED060000000000001D0000000000000000000000000000000000000000000000000000000000B1', null, '101102'), ('154', '0601', '1', '00000000000F', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '020101DC21B8073CE127011B08FC5618A053060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 05:21:23', '2015-10-10 13:21:47', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618A05300000000000F060100010F000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400020101DC21B8073CE127011B08FC5618A053060000000000001D0000000000000000000000000000000000000000000000000000000000D1', null, '101102'), ('155', '0601', '1', '000000000010', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '020101DC2099073CE19E000000005618A0B9060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 05:23:05', '2015-10-10 13:23:28', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618A0B90000000000100601000110000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400020101DC2099073CE19E000000005618A0B9060000000000001D0000000000000000000000000000000000000000000000000000000000A6', null, '101102'), ('156', '0601', '1', '000000000011', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '020101DC20D2073CE2E5000000005618A11E060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 05:24:46', '2015-10-10 13:25:12', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618A11E0000000000110601000111000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400020101DC20D2073CE2E5000000005618A11E060000000000001D000000000000000000000000000000000000000000000000000000000095', null, '101102'), ('157', '0601', '1', '000000000012', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '020101DC2205073CE261000000005618A184060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 05:26:28', '2015-10-10 13:26:52', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618A1840000000000120601000112000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400020101DC2205073CE261000000005618A184060000000000001D0000000000000000000000000000000000000000000000000000000000C4', null, '101102'), ('158', '0601', '1', '000000000013', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '020101DC20E6073CE172000000005618A1ED060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 05:28:13', '2015-10-10 13:28:36', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618A1ED0000000000130601000113000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400020101DC20E6073CE172000000005618A1ED060000000000001D000000000000000000000000000000000000000000000000000000000035', null, '101102'), ('159', '0601', '1', '000000000014', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '020101DC1E71073CE2D1000000005618A24F060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 05:29:51', '2015-10-10 13:30:15', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618A24F0000000000140601000114000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400020101DC1E71073CE2D1000000005618A24F060000000000001D00000000000000000000000000000000000000000000000000000000003C', null, '101102'), ('160', '0601', '1', '000000000015', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '020101DC1F5C073CE24E000000005618A2B5060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 05:31:33', '2015-10-10 13:31:57', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618A2B50000000000150601000115000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400020101DC1F5C073CE24E000000005618A2B5060000000000001D00000000000000000000000000000000000000000000000000000000008F', null, '101102'), ('161', '0601', '1', '000000000016', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '020101DC1ED4073CE2E0004E0B545618A31B060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 05:33:15', '2015-10-10 13:33:39', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618A31B0000000000160601000116000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400020101DC1ED4073CE2E0004E0B545618A31B060000000000001D0000000000000000000000000000000000000000000000000000000000B9', null, '101102'), ('162', '0601', '1', '000000000017', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '020101DC1F3E073CE251000000005618A381060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 05:34:57', '2015-10-10 13:35:20', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618A3810000000000170601000117000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400020101DC1F3E073CE251000000005618A381060000000000001D0000000000000000000000000000000000000000000000000000000000F2', null, '101102'), ('163', '0601', '1', '000000000018', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '020101DC1EAC073CE3FE001208345618A3E7060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 05:36:39', '2015-10-10 13:37:02', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618A3E70000000000180601000118000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400020101DC1EAC073CE3FE001208345618A3E7060000000000001D0000000000000000000000000000000000000000000000000000000000E1', null, '101102'), ('164', '0601', '1', '000000000019', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '020101DC1F51073CE16A0111049C5618A44C060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 05:38:20', '2015-10-10 13:38:43', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618A44C0000000000190601000119000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400020101DC1F51073CE16A0111049C5618A44C060000000000001D00000000000000000000000000000000000000000000000000000000002D', null, '101102'), ('165', '0601', '1', '00000000001A', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '020101DC1F2C073CE1D9011A25E45618A4B2060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 05:40:02', '2015-10-10 13:40:25', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618A4B200000000001A060100011A000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400020101DC1F2C073CE1D9011A25E45618A4B2060000000000001D0000000000000000000000000000000000000000000000000000000000B1', null, '101102'), ('166', '0601', '1', '00000000001B', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '020101DC2078073CDA4C011B0A8C5618A518060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 05:41:44', '2015-10-10 13:42:07', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618A51800000000001B060100011B000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400020101DC2078073CDA4C011B0A8C5618A518060000000000001D000000000000000000000000000000000000000000000000000000000032', null, '101102'), ('167', '0601', '1', '00000000001C', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '020101DC1F6D073CE21B005D20085618A57E060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 05:43:26', '2015-10-10 13:43:48', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618A57E00000000001C060100011C000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400020101DC1F6D073CE21B005D20085618A57E060000000000001D00000000000000000000000000000000000000000000000000000000009E', null, '101102');
INSERT INTO `tbox_msglog_copy` VALUES ('168', '0601', '1', '00000000001D', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '020101DC1E93073CE29001080A285618A5E3060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 05:45:07', '2015-10-10 13:45:30', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618A5E300000000001D060100011D000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400020101DC1E93073CE29001080A285618A5E3060000000000001D0000000000000000000000000000000000000000000000000000000000B4', null, '101102'), ('169', '0601', '1', '00000000001E', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618A649060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 05:46:49', '2015-10-10 13:47:12', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618A64900000000001E060100011E000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618A649060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('170', '0601', '1', '00000000001F', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618A6AF060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 05:48:31', '2015-10-10 13:48:53', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618A6AF00000000001F060100011F000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618A6AF060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('171', '0601', '1', '000000000020', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618A714060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 05:50:12', '2015-10-10 13:50:35', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618A7140000000000200601000120000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618A714060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('172', '0601', '1', '000000000021', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618A77A060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 05:51:54', '2015-10-10 13:52:17', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618A77A0000000000210601000121000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618A77A060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('173', '0601', '1', '000000000022', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618A7E0060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 05:53:36', '2015-10-10 13:53:58', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618A7E00000000000220601000122000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618A7E0060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('174', '0601', '1', '000000000023', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618A845060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 05:55:17', '2015-10-10 13:55:40', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618A8450000000000230601000123000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618A845060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('175', '0601', '1', '000000000024', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618A8AB060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 05:56:59', '2015-10-10 13:57:22', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618A8AB0000000000240601000124000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618A8AB060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('176', '0401', '1', '000000000001', '15415025L990997913600U0010', '460036641469974', '11111111111111111', 'FF3131313131313131313131313131313131', '2015-10-10 05:58:21', '2015-10-10 13:58:44', null, '101000', null, null, null, null, null, null, '464C432E0000690057005618A8FD0000000000010401000101000012000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400FF31313131313131313131313131313131318B', null, null), ('177', '0401', '1', '000000000001', '15415025L990997913600U0010', '460036641469974', '11111111111111111', 'FF3131313131313131313131313131313131', '2015-10-10 06:00:04', '2015-10-10 14:00:26', null, '101000', null, null, null, null, null, null, '464C432E0000690057005618A9640000000000010401000101000012000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400FF313131313131313131313131313131313113', null, null), ('178', '0401', '1', '000000000001', '15415025L990997913600U0010', '460036641469974', '11111111111111111', 'FF3131313131313131313131313131313131', '2015-10-10 06:02:03', '2015-10-10 14:04:37', null, '101000', null, null, null, null, null, null, '464C432E0000690057005618A9DB0000000000010401000101000012000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400FF3131313131313131313131313131313131AC', null, null), ('179', '0601', '1', '000000000002', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618AA1E060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 06:03:10', '2015-10-10 14:05:44', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618AA1E0000000000020601000102000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618AA1E060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('180', '0601', '1', '000000000003', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618AA85060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 06:04:53', '2015-10-10 14:07:27', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618AA850000000000030601000103000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618AA85060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('181', '0601', '1', '000000000004', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618AAEA060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 06:06:34', '2015-10-10 14:09:07', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618AAEA0000000000040601000104000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618AAEA060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('182', '0601', '1', '000000000005', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618AB4F060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 06:08:15', '2015-10-10 14:10:49', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618AB4F0000000000050601000105000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618AB4F060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('183', '0601', '1', '000000000006', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618ABB5060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 06:09:57', '2015-10-10 14:12:31', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618ABB50000000000060601000106000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618ABB5060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('184', '0601', '1', '000000000007', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618AC1B060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 06:11:39', '2015-10-10 14:14:12', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618AC1B0000000000070601000107000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618AC1B060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('185', '0601', '1', '000000000008', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618AC80060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 06:13:20', '2015-10-10 14:15:54', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618AC800000000000080601000108000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618AC80060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('186', '0601', '1', '000000000009', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618ACE6060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 06:15:02', '2015-10-10 14:17:36', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618ACE60000000000090601000109000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618ACE6060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('187', '0601', '1', '00000000000A', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618AD4C060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 06:16:44', '2015-10-10 14:19:17', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618AD4C00000000000A060100010A000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618AD4C060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('188', '0601', '1', '00000000000B', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618ADB1060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 06:18:25', '2015-10-10 14:20:59', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618ADB100000000000B060100010B000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618ADB1060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('189', '0601', '1', '00000000000C', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618AE17060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 06:20:07', '2015-10-10 14:22:41', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618AE1700000000000C060100010C000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618AE17060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('190', '0601', '1', '00000000000D', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618AE7D060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 06:21:49', '2015-10-10 14:24:22', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618AE7D00000000000D060100010D000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618AE7D060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('191', '0601', '1', '00000000000E', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618AEE2060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 06:23:30', '2015-10-10 14:26:04', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618AEE200000000000E060100010E000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618AEE2060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('192', '0601', '1', '00000000000F', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618AF48060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 06:25:12', '2015-10-10 14:27:46', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618AF4800000000000F060100010F000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618AF48060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('193', '0601', '1', '000000000010', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618AFAE060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 06:26:54', '2015-10-10 14:29:27', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618AFAE0000000000100601000110000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618AFAE060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('194', '0601', '1', '000000000011', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618B013060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 06:28:35', '2015-10-10 14:31:09', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618B0130000000000110601000111000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618B013060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('195', '0601', '1', '000000000012', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618B079060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 06:30:17', '2015-10-10 14:32:51', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618B0790000000000120601000112000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618B079060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('196', '0601', '1', '000000000013', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618B0DF060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 06:31:59', '2015-10-10 14:34:33', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618B0DF0000000000130601000113000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618B0DF060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('197', '0601', '1', '000000000014', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618B145060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 06:33:41', '2015-10-10 14:36:14', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618B1450000000000140601000114000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618B145060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('198', '0601', '1', '000000000015', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618B1AA060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 06:35:22', '2015-10-10 14:37:56', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618B1AA0000000000150601000115000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618B1AA060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('199', '0601', '1', '000000000016', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '02000000000000000000000000005618B210060000000000001D0000000000000000000000000000000000000000000000000000000000', '2015-10-10 06:37:04', '2015-10-10 14:39:38', null, '101000', null, null, null, null, null, null, '464C432E00008E0057005618B2100000000000160601000116000037000000000000313131313131313131313131313131313131353431353032354C3939303939373931333630305530303130343630303336363431343639393734010203040002000000000000000000000000005618B210060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102'), ('200', '0401', '1', '000000000001', '15415025L990997913600U0010', '460036641469974', '11111111111111111', 'FF3131313131313131313131313131313131', '2048-02-21 13:05:34', '2015-10-16 09:45:54', null, '101000', null, null, null, null, null, null, '464C432E00006900570092FAB21E0000000000010401000101000012000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400FF313131313131313131313131313131313154', null, '0'), ('201', '0601', '1', '000000000002', '15415025L990997913600U0010', '460036641469974', '11111111111111111', '020000000000000000000000000092FAB261060000000000001D0000000000000000000000000000000000000000000000000000000000', '2048-02-21 13:06:41', '2015-10-16 09:47:02', null, '101000', null, null, null, null, null, null, '464C432E00008E00570092FAB2610000000000020601000102000037000000000000313131313131313131313131313131313131353431353032354C39393039393739313336303055303031303436303033363634313436393937340102030400020000000000000000000000000092FAB261060000000000001D000000000000000000000000000000000000000000000000000000000087', null, '101102');
COMMIT;

-- ----------------------------
-- Function structure for `countStr`
-- ----------------------------
DROP FUNCTION IF EXISTS `countStr`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `countStr`(x varchar(255), delim varchar(12)) RETURNS int(11)
return (length(x)-length(REPLACE(x, delim, '')))/length(delim)
;;
DELIMITER ;

-- ----------------------------
-- Function structure for `getMenuChildidList`
-- ----------------------------
DROP FUNCTION IF EXISTS `getMenuChildidList`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `getMenuChildidList`(rootId VARCHAR(32)) RETURNS text CHARSET utf8
BEGIN
	DECLARE sTemp text;
	DECLARE sTempChd text; 
	SET@@group_concat_max_len = 102400;
	SET sTemp = '$'; 
	SET sTempChd = rootId;

	WHILE sTempChd IS NOT NULL DO 
	SET sTemp = concat(sTemp, ',', sTempChd);
	SELECT 
		group_concat(id) INTO sTempChd 
	FROM 
		jfk_menu
	WHERE
		FIND_IN_SET(pid, sTempChd) > 0;
	END WHILE; 
	SET@@group_concat_max_len = 1024;
	RETURN SUBSTRING(sTemp,3); 
END
;;
DELIMITER ;

-- ----------------------------
-- Function structure for `getMenuParentPath`
-- ----------------------------
DROP FUNCTION IF EXISTS `getMenuParentPath`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `getMenuParentPath`(childId VARCHAR(32)) RETURNS text CHARSET utf8
BEGIN
DECLARE sTemp text;
DECLARE sTempChd text;
DECLARE iOrder,iCount int;

SET sTemp = '$'; 
SET sTempChd = childId;
SET iOrder = 0;
set iCount = 0;

WHILE sTempChd IS NOT NULL DO
SET sTemp = concat(sTempChd ,',',sTemp);
SELECT
	pid,order_num INTO sTempChd,iOrder
FROM
	jfk_menu
WHERE
	id=sTempChd;


END WHILE;

RETURN SUBSTRING(sTemp ,1 ,LENGTH(sTemp)-2);


END
;;
DELIMITER ;

-- ----------------------------
-- Auto increment value for `jfk_dict`
-- ----------------------------
ALTER TABLE `jfk_dict` AUTO_INCREMENT=300004;

-- ----------------------------
-- Auto increment value for `jfk_dict_type`
-- ----------------------------
ALTER TABLE `jfk_dict_type` AUTO_INCREMENT=1012;

-- ----------------------------
-- Auto increment value for `jfk_menu`
-- ----------------------------
ALTER TABLE `jfk_menu` AUTO_INCREMENT=21;

-- ----------------------------
-- Auto increment value for `jfk_org`
-- ----------------------------
ALTER TABLE `jfk_org` AUTO_INCREMENT=3;

-- ----------------------------
-- Auto increment value for `jfk_role`
-- ----------------------------
ALTER TABLE `jfk_role` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for `jfk_urls`
-- ----------------------------
ALTER TABLE `jfk_urls` AUTO_INCREMENT=16;

-- ----------------------------
-- Auto increment value for `jfk_user`
-- ----------------------------
ALTER TABLE `jfk_user` AUTO_INCREMENT=24568;

-- ----------------------------
-- Auto increment value for `tbox_device`
-- ----------------------------
ALTER TABLE `tbox_device` AUTO_INCREMENT=3;

-- ----------------------------
-- Auto increment value for `tbox_msglog`
-- ----------------------------
ALTER TABLE `tbox_msglog` AUTO_INCREMENT=394;

-- ----------------------------
-- Auto increment value for `tbox_msglog_copy`
-- ----------------------------
ALTER TABLE `tbox_msglog_copy` AUTO_INCREMENT=202;
